1 Load data

df <- read.table('../../../output/first_try/report/summary_table.txt', header = T)
df$rownum <- 1 : nrow(df)

df.sub <- df[df$motif_qval < 0.05 & abs(df$r) > 0.5, ]
df.sub$strand <- as.character(df.sub$strand)
df.sub$strand[df.sub$strand == '-'] <- 'negative'
df.sub$strand[df.sub$strand == '+'] <- 'positive'
row.names(df.sub) <- NULL
motif_logo_prefix <- '../../../output/first_try/report/motif_logo/'
mash_plot_prefix <- '../../../output/first_try/report/mash_plot//mash__idx'
for(i in 1 : nrow(df.sub)) {
    motif_logo <- paste0(motif_logo_prefix, df.sub$dbname[i], '__', df.sub$motif_id[i], '.png')
    mash_plot <- paste0(mash_plot_prefix, df.sub$idx[i], '.png')
    cat('#', as.character(df.sub$gene_name[i]), as.character(df$motif_id[i]), '\n', '\n')
    df.show <- df.sub[, - which(colnames(df.sub) %in% c('idx', 'motif_from', 'motif_matched_sequence', 'motif_qval', 'dbname', 'rownum'))]
    pander(df.show[i, ])
    img1 <- rasterGrob(as.raster(readPNG(motif_logo)), interpolate = FALSE)
    img2 <- rasterGrob(as.raster(readPNG(mash_plot)), interpolate = FALSE)
    grid.arrange(img1, img2, ncol = 2)
    # cat(motif_logo, mash_plot, '\n')
    # df.sub[i, ] %>% kable(format = "html", col.names = colnames(df.sub)) %>%
    #   kable_styling() %>%
    #   kableExtra::scroll_box(width = "100%", height = "200px")
    cat('\n', '\n')
}

2 WDR59 COT2_HUMAN.H11MO.1.A

gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
WDR59 ENSG00000103091 16_74937232_T_A_b37 16_74938857_G_A_b37 0.6468 MA0512.2 Rxra 13 14 negative Heart_Atrial_Appendage

3 TMA7 COT2_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
2 TMA7 ENSG00000232112 3_48479207_C_T_b37 3_48481647_G_A_b37 0.9999 SP1_HUMAN.H11MO.1.A NA 2 14 positive Heart_Atrial_Appendage

4 TMA7 MA0512.2

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
3 TMA7 ENSG00000232112 3_48479207_C_T_b37 3_48481647_G_A_b37 0.9999 SP1_HUMAN.H11MO.0.A NA 2 22 positive Heart_Atrial_Appendage

5 GNB4 MA0677.1

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
4 GNB4 ENSG00000114450 3_179172979_G_T_b37 3_179168958_T_C_b37 0.5028 SP1_HUMAN.H11MO.0.A NA 14 22 negative Heart_Atrial_Appendage

6 RIC8A SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
5 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207693_CG_C_b37 0.5548 SP1_HUMAN.H11MO.1.A NA 7 14 positive Heart_Atrial_Appendage

7 RIC8A SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
6 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207693_CG_C_b37 0.5548 SP1_HUMAN.H11MO.1.A NA 12 14 positive Heart_Atrial_Appendage

8 RIC8A SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
7 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207693_CG_C_b37 0.5548 SP1_HUMAN.H11MO.0.A NA 12 22 positive Heart_Atrial_Appendage

9 RIC8A SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
8 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207693_CG_C_b37 0.5548 SP1_HUMAN.H11MO.0.A NA 7 22 positive Heart_Atrial_Appendage

10 RIC8A MEF2A_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
9 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207693_CG_C_b37 0.5548 SP1_HUMAN.H11MO.0.A NA 17 22 positive Heart_Atrial_Appendage

11 RIC8A SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
10 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207698_C_T_b37 0.5706 SP1_HUMAN.H11MO.1.A NA 12 14 positive Heart_Atrial_Appendage

12 RIC8A SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
11 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207698_C_T_b37 0.5706 SP1_HUMAN.H11MO.0.A NA 17 22 positive Heart_Atrial_Appendage

13 RIC8A SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
12 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207698_C_T_b37 0.5706 SP1_HUMAN.H11MO.0.A NA 12 22 positive Heart_Atrial_Appendage

14 RIC8A SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
13 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207698_C_T_b37 0.5706 SP1_HUMAN.H11MO.0.A NA 22 22 positive Heart_Atrial_Appendage

15 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
14 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.1.A NA 8 14 negative Heart_Atrial_Appendage

16 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
15 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 8 22 negative Heart_Atrial_Appendage

17 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
16 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 15 22 negative Heart_Atrial_Appendage

18 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
17 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 2 22 negative Heart_Atrial_Appendage

19 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
18 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 17 22 negative Heart_Atrial_Appendage

20 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
19 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 13 22 negative Heart_Atrial_Appendage

21 PRKCA SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
20 PRKCA ENSG00000154229 17_64315205_A_C_b37 17_64298682_G_A_b37 -0.9084 SP1_HUMAN.H11MO.0.A NA 21 22 positive Heart_Atrial_Appendage

22 PRKCA SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
21 PRKCA ENSG00000154229 17_64315205_A_C_b37 17_64298682_G_A_b37 -0.9084 SP1_HUMAN.H11MO.0.A NA 16 22 negative Heart_Atrial_Appendage

23 RAB40B SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
22 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.7073 SP1_HUMAN.H11MO.0.A NA 22 22 negative Heart_Atrial_Appendage

24 RAB40B SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
23 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.7073 SP1_HUMAN.H11MO.0.A NA 12 22 negative Heart_Atrial_Appendage

25 RAB40B SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
24 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.7073 SP1_HUMAN.H11MO.0.A NA 17 22 negative Heart_Atrial_Appendage

26 RAB40B SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
25 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.7073 SP1_HUMAN.H11MO.1.A NA 12 14 negative Heart_Atrial_Appendage

27 SIPA1L3 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
26 SIPA1L3 ENSG00000105738 19_38670754_C_T_b37 19_38664097_C_T_b37 0.9999 SP1_HUMAN.H11MO.0.A NA 14 22 negative Heart_Atrial_Appendage

28 SIPA1L3 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
27 SIPA1L3 ENSG00000105738 19_38670754_C_T_b37 19_38664097_C_T_b37 0.9999 SP1_HUMAN.H11MO.0.A NA 18 22 positive Heart_Atrial_Appendage

29 CCDC157 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
28 CCDC157 ENSG00000187860 22_30765502_G_A_b37 22_30752942_C_A_b37 0.9832 SP1_HUMAN.H11MO.0.A NA 8 22 negative Heart_Atrial_Appendage

30 CCDC157 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
29 CCDC157 ENSG00000187860 22_30765502_G_A_b37 22_30752942_C_A_b37 0.9832 SP1_HUMAN.H11MO.0.A NA 2 22 negative Heart_Atrial_Appendage

31 TMA7 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
30 TMA7 ENSG00000232112 3_48479207_C_T_b37 3_48481647_G_A_b37 0.9999 MA0079.3 SP1 11 11 negative Heart_Atrial_Appendage

32 RIC8A SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
31 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207693_CG_C_b37 0.5548 MA0079.3 SP1 5 11 negative Heart_Atrial_Appendage

33 RIC8A SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
32 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207693_CG_C_b37 0.5548 MA0079.3 SP1 0 11 negative Heart_Atrial_Appendage

34 RIC8A SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
33 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207698_C_T_b37 0.5706 MA0079.3 SP1 1 11 negative Heart_Atrial_Appendage

35 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
34 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 MA0079.3 SP1 5 11 positive Heart_Atrial_Appendage

36 WDR59 SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
35 WDR59 ENSG00000103091 16_74937232_T_A_b37 16_74938857_G_A_b37 0.7172 MA0512.2 Rxra 13 14 negative Heart_Left_Ventricle

37 TMA7 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
36 TMA7 ENSG00000232112 3_48479207_C_T_b37 3_48481647_G_A_b37 0.9999 SP1_HUMAN.H11MO.1.A NA 2 14 positive Heart_Left_Ventricle

38 TMA7 SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
37 TMA7 ENSG00000232112 3_48479207_C_T_b37 3_48481647_G_A_b37 0.9999 SP1_HUMAN.H11MO.0.A NA 2 22 positive Heart_Left_Ventricle

39 GNB4 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
38 GNB4 ENSG00000114450 3_179172979_G_T_b37 3_179168958_T_C_b37 0.5479 SP1_HUMAN.H11MO.0.A NA 14 22 negative Heart_Left_Ventricle

40 RIC8A SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
39 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207693_CG_C_b37 0.5375 SP1_HUMAN.H11MO.1.A NA 7 14 positive Heart_Left_Ventricle

41 RIC8A SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
40 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207693_CG_C_b37 0.5375 SP1_HUMAN.H11MO.1.A NA 12 14 positive Heart_Left_Ventricle

42 RIC8A SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
41 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207693_CG_C_b37 0.5375 SP1_HUMAN.H11MO.0.A NA 12 22 positive Heart_Left_Ventricle

43 RIC8A SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
42 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207693_CG_C_b37 0.5375 SP1_HUMAN.H11MO.0.A NA 7 22 positive Heart_Left_Ventricle

44 RIC8A SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
43 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207693_CG_C_b37 0.5375 SP1_HUMAN.H11MO.0.A NA 17 22 positive Heart_Left_Ventricle

45 RIC8A SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
44 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207698_C_T_b37 0.5513 SP1_HUMAN.H11MO.1.A NA 12 14 positive Heart_Left_Ventricle

46 RIC8A SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
45 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207698_C_T_b37 0.5513 SP1_HUMAN.H11MO.0.A NA 17 22 positive Heart_Left_Ventricle

47 RIC8A SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
46 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207698_C_T_b37 0.5513 SP1_HUMAN.H11MO.0.A NA 12 22 positive Heart_Left_Ventricle

48 RIC8A SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
47 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207698_C_T_b37 0.5513 SP1_HUMAN.H11MO.0.A NA 22 22 positive Heart_Left_Ventricle

49 CDH24 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
48 CDH24 ENSG00000139880 14_23515986_A_T_b37 14_23525653_G_A_b37 0.5152 SP1_HUMAN.H11MO.0.A NA 6 22 positive Heart_Left_Ventricle

50 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
49 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.1.A NA 8 14 negative Heart_Left_Ventricle

51 PDIA2 SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
50 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 8 22 negative Heart_Left_Ventricle

52 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
51 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 15 22 negative Heart_Left_Ventricle

53 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
52 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 2 22 negative Heart_Left_Ventricle

54 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
53 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 17 22 negative Heart_Left_Ventricle

55 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
54 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 13 22 negative Heart_Left_Ventricle

56 PRKCA SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
55 PRKCA ENSG00000154229 17_64315205_A_C_b37 17_64298682_G_A_b37 -0.8786 SP1_HUMAN.H11MO.0.A NA 21 22 positive Heart_Left_Ventricle

57 PRKCA SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
56 PRKCA ENSG00000154229 17_64315205_A_C_b37 17_64298682_G_A_b37 -0.8786 SP1_HUMAN.H11MO.0.A NA 16 22 negative Heart_Left_Ventricle

58 RAB40B SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
57 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.7685 SP1_HUMAN.H11MO.0.A NA 22 22 negative Heart_Left_Ventricle

59 RAB40B SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
58 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.7685 SP1_HUMAN.H11MO.0.A NA 12 22 negative Heart_Left_Ventricle

60 RAB40B SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
59 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.7685 SP1_HUMAN.H11MO.0.A NA 17 22 negative Heart_Left_Ventricle

61 RAB40B SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
60 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.7685 SP1_HUMAN.H11MO.1.A NA 12 14 negative Heart_Left_Ventricle

62 SIPA1L3 SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
61 SIPA1L3 ENSG00000105738 19_38670754_C_T_b37 19_38664097_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 14 22 negative Heart_Left_Ventricle

63 SIPA1L3 SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
62 SIPA1L3 ENSG00000105738 19_38670754_C_T_b37 19_38664097_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 18 22 positive Heart_Left_Ventricle

64 CCDC157 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
63 CCDC157 ENSG00000187860 22_30765502_G_A_b37 22_30752942_C_A_b37 0.9807 SP1_HUMAN.H11MO.0.A NA 8 22 negative Heart_Left_Ventricle

65 CCDC157 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
64 CCDC157 ENSG00000187860 22_30765502_G_A_b37 22_30752942_C_A_b37 0.9807 SP1_HUMAN.H11MO.0.A NA 2 22 negative Heart_Left_Ventricle

66 TMA7 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
65 TMA7 ENSG00000232112 3_48479207_C_T_b37 3_48481647_G_A_b37 0.9999 MA0079.3 SP1 11 11 negative Heart_Left_Ventricle

67 RIC8A SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
66 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207693_CG_C_b37 0.5375 MA0079.3 SP1 5 11 negative Heart_Left_Ventricle

68 RIC8A SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
67 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207693_CG_C_b37 0.5375 MA0079.3 SP1 0 11 negative Heart_Left_Ventricle

69 RIC8A SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
68 RIC8A ENSG00000177963 11_246370_C_T_b37 11_207698_C_T_b37 0.5513 MA0079.3 SP1 1 11 negative Heart_Left_Ventricle

70 PDIA2 SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
69 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 MA0079.3 SP1 5 11 positive Heart_Left_Ventricle

71 WDR59 SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
70 WDR59 ENSG00000103091 16_74937232_T_A_b37 16_74938857_G_A_b37 0.6947 MA0512.2 Rxra 13 14 negative Muscle_Skeletal

72 TMA7 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
71 TMA7 ENSG00000232112 3_48479207_C_T_b37 3_48481647_G_A_b37 1 SP1_HUMAN.H11MO.1.A NA 2 14 positive Muscle_Skeletal

73 TMA7 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
72 TMA7 ENSG00000232112 3_48479207_C_T_b37 3_48481647_G_A_b37 1 SP1_HUMAN.H11MO.0.A NA 2 22 positive Muscle_Skeletal

74 GNB4 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
73 GNB4 ENSG00000114450 3_179172979_G_T_b37 3_179168958_T_C_b37 0.5507 SP1_HUMAN.H11MO.0.A NA 14 22 negative Muscle_Skeletal

75 CDH24 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
74 CDH24 ENSG00000139880 14_23515986_A_T_b37 14_23525653_G_A_b37 0.5342 SP1_HUMAN.H11MO.0.A NA 6 22 positive Muscle_Skeletal

76 PDIA2 SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
75 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.1.A NA 8 14 negative Muscle_Skeletal

77 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
76 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 8 22 negative Muscle_Skeletal

78 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
77 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 15 22 negative Muscle_Skeletal

79 PDIA2 SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
78 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 2 22 negative Muscle_Skeletal

80 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
79 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 17 22 negative Muscle_Skeletal

81 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
80 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 13 22 negative Muscle_Skeletal

82 PRKCA SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
81 PRKCA ENSG00000154229 17_64315205_A_C_b37 17_64298682_G_A_b37 -0.8875 SP1_HUMAN.H11MO.0.A NA 21 22 positive Muscle_Skeletal

83 PRKCA SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
82 PRKCA ENSG00000154229 17_64315205_A_C_b37 17_64298682_G_A_b37 -0.8875 SP1_HUMAN.H11MO.0.A NA 16 22 negative Muscle_Skeletal

84 RAB40B SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
83 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.7216 SP1_HUMAN.H11MO.0.A NA 22 22 negative Muscle_Skeletal

85 RAB40B SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
84 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.7216 SP1_HUMAN.H11MO.0.A NA 12 22 negative Muscle_Skeletal

86 RAB40B SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
85 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.7216 SP1_HUMAN.H11MO.0.A NA 17 22 negative Muscle_Skeletal

87 RAB40B SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
86 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.7216 SP1_HUMAN.H11MO.1.A NA 12 14 negative Muscle_Skeletal

88 SIPA1L3 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
87 SIPA1L3 ENSG00000105738 19_38670754_C_T_b37 19_38664097_C_T_b37 0.9997 SP1_HUMAN.H11MO.0.A NA 14 22 negative Muscle_Skeletal

89 SIPA1L3 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
88 SIPA1L3 ENSG00000105738 19_38670754_C_T_b37 19_38664097_C_T_b37 0.9997 SP1_HUMAN.H11MO.0.A NA 18 22 positive Muscle_Skeletal

90 CCDC157 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
89 CCDC157 ENSG00000187860 22_30765502_G_A_b37 22_30752942_C_A_b37 0.985 SP1_HUMAN.H11MO.0.A NA 8 22 negative Muscle_Skeletal

91 CCDC157 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
90 CCDC157 ENSG00000187860 22_30765502_G_A_b37 22_30752942_C_A_b37 0.985 SP1_HUMAN.H11MO.0.A NA 2 22 negative Muscle_Skeletal

92 TMA7 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
91 TMA7 ENSG00000232112 3_48479207_C_T_b37 3_48481647_G_A_b37 1 MA0079.3 SP1 11 11 negative Muscle_Skeletal

93 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r motif_id motif_name motif_snp.pos motif.length strand tissue
92 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 MA0079.3 SP1 5 11 positive Muscle_Skeletal